-- 目的中心到不同网点分段货量统计
CREATE EXTERNAL TABLE jms_dm.dm_end_center_network_time_interval_detail_dt(
  `billcode` string COMMENT '运单号',
  `scantime` timestamp COMMENT '卸车到件时间',
  `end_center_code` string COMMENT '末端中心编码',
  `end_center_name` string COMMENT '末端中心名称',
  `subordinate_agent_code` string COMMENT '代理区编码',
  `subordinate_agent_name` string COMMENT '代理区名称',
  `terminal_dispatch_code` string COMMENT '三段码',
  `end_network_code` string COMMENT '末端网点编码',
  `end_network_name` string COMMENT '末端网点名称',
  `time_stage` string COMMENT '所属小时段')
COMMENT '目的中心到目的网点时段统计明细'
PARTITIONED BY (
  `dt` string COMMENT '日期分区(卸车到件时间)')
   STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_end_center_network_time_interval_detail_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );